In this example I will show you how to create xml document using Linq .In order to extract data from a database and create an xml document we need to include the namespace using System.Xml.Linq. The important class with the Linq to Xml hierarchy XElements and XDocument, XElement class represents an XML element node that contains child elements as child nodes.The output xml file will be saved at a specified location of the project folder.
This example I used northwind sample database for more detail about how to download click link button it will show a popup.
Example:
protected void Page_Load(object sender, EventArgs e)
{
models db = new models();
var customerOrders = from customer in db.Customers
where customer.ContactName.StartsWith("C") && customer.Orders.Count> 0
orderby customer.ContactName
select customer;
var xml = new XElement("customers", from customer in customerOrders.ToList()
select new XElement("ContactName",
new XAttribute("ContactName", customer.ContactName), new XAttribute("phone", customer.Phone)));
var path = Path.Combine(Server.MapPath("~/Xmlfiles"), "file1" + ".xml");
System.IO.File.WriteAllText(path,xml.ToString());
}
Output:
Post your comments / questions
Recent Article
- The request was aborted: Could not create SSL/TLS secure channel -Error in Asp.net
- FieldError: Cannot resolve keyword 'id' into field in Django project
- How to hide the ID field from the Django admin?
- It is impossible to add a non nullable field without specifying a default. Django error
- ImportError: cannot import name 'url' from 'django.conf.urls' - Django Error
- How to Enable Virtualization in BIOS Security Settings in Intel Processors For Android Studio?
- Dependency 'androidx.activity:activity:1.8.0' requires libraries and applications that depend on it.
- AttributeError: 'NoneType' object has no attribute 'get_text' - Python
Related Article